Aside

logo

Contact

Language Skills

R
Tableau
Hive
Python
Bash
SQL

Disclaimer

Made w/ pagedown.

Source code adapted with gratitude from: github.com/nstrayer/cv.

Last updated on 2020-06-10.

Main

Kyle McGillicuddy-Penna

I have made visualizations viewed by hundreds of thousands of people, sped up query times for 25 terabytes of data by an average of 4,800 times, and built packages for R that let you do magic.

Currently searching for a position that allows me to build tools leveraging a combination of visualization, machine learning, and software engineering to help people explore and understand their data in new and useful ways.

Skills

Communication: action oriented translator.

N/A

N/A

N/A

  • Proven ability to connect with stakeholders across functions, teams, and experience levels.
  • Practiced listener, precise speaker, analytical thinker.
  • Eliminate vagueness, even while describing complexity or uncertainty.
  • Ask hard questions and push for answers that drive improvements.
  • Graphical communication via Tableau, R, Excel.

Data access: experienced SQL writer, reader, and editor.

N/A

N/A

N/A

  • PLSQL package development.
  • Query optimization in a medium to large (billion row, non-distributed) data setting.

Data analysis: R to read, wrangle, explore, visualize, and model, mostly via the tidyverse.

N/A

N/A

N/A

Data storage (warehousing + ETL) via:

N/A

N/A

N/A

  • Dimensional modeling: star + snowflake schemas + Kimball best practices.
  • Database design: table creation and data normalization, data typing, constraints, indexes.
  • PLSQL: scheduler + packages + triggers + stored procedures.
  • Pentaho’s Data Integration.
  • Cron + shell scripts.

Education

B.A. in Engineering Psychology

Tufts University

Medford, Massachusetts.

2004 - 2000

  • Honors, Dean’s List.

Minor in Studio Art

The School of the Museum of Fine Arts

Boston, Massachusetts.

2004 - 2003

Selected Positions

Inmar

Data Governance Lead

Seattle, WA

2020 - 2019

YOU Technology (purchased by Kroger in 2014)

Business Intelligence Lead

Daly City, California

2019 - 2012

  • Focus on scaling data resources to support 100%+ yearly customer and revenue growth over multiple years.
  • Own data related product development process: ensure clear and achievable requirements, leading to better tools to inform decision makers.
  • Hire, manage, and mentor a small team of engineers and analysts.

YOU Technology

Senior Business Analyst

Daly City, California

2012 - 2011

  • Collaborate with management to identify, track, and present best metrics of business impact; present those metrics to team leaders via executive dashboards.
  • Build and maintain data warehouse and client facing reporting site to allow retailers to independently monitor and analyze campaigns.

YOU Technology

Business Analyst

Daly City, California

2011 - 2007

  • Compile business reviews to identify trends, recognize successful tactics, and uncover areas for improvement as YOU Tech builds the first digital coupon platform.
  • Support successful integration with multiple retailers’ heterogeneous and minimally documented loyalty and POS systems through data exploration and ongoing data quality monitoring.
  • Reduce average report development time exponentially by creating reusable parameterized SQL+shell script.

Loyalty Matrix (purchased by Responsys in 2007)

Business Analyst

San Francisco, California

2007 - 2005

  • Model customer lifetime value across segments to ensure investments in acquisition and retention are profitable.
  • Analyze campaign and email performance to identify effective messaging, timing, and targeting.
  • Manage offshore development team to coordinate completion of multiple concurrent ETL and QA processes on deadline and within budget.

Private Residence

Chef

San Francisco, California

2005 - 2004

Department of Transportation, Research Center

Research Assistant

Cambridge, MA

2004 - 2003

  • Assist lead investigators with all aspects of experiments (design, description, information collection and analysis) on operator fatigue and automated crash avoidance systems.
  • Lead the evaluation and selection process of motion trackers to be used in research.